package com.bw.bean;

import lombok.Data;

/**
 * @BelongsProject: yuekao
 * @BelongsPackage: com.bw.bean
 * @Author: cuizexuan
 * @CreateTime: 2024-10-11  09:30
 * @Description: TODO
 * @Version: 1.0
 */
@Data
public class Vo4 {

    //select
    //    s.name,
    //    sum(oi.reduce_amount) `value`,
    //    rank() over (order by sum(oi.reduce_amount) desc) `lot`,
    //    count(oi.id) `num`
    //from order_info oi
    //         left join payment p on oi.id = p.order_info_id
    //         left join shop s on oi.shop_id = s.id
    //group by s.name order by sum(oi.reduce_amount) desc limit 10

    private String name;
    private Double value;
    private String lot;
    private Integer num;
}
